# Copyright© 2021 谈翰文
#
#         This program is free software: you can redistribute it and/or modify
#         it under the terms of the GNU General Public License as published by
#         the Free Software Foundation, either version 3 of the License, or
#         (at your option) any later version.
#
#         This program is distributed in the hope that it will be useful,
#         but WITHOUT ANY WARRANTY; without even the implied warranty of
#         MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
#         GNU General Public License for more details.
#
#         You should have received a copy of the GNU General Public License
#         along with this program.  If not, see <https://www.gnu.org/licenses/>.
import sqlite3

conn = sqlite3.connect('bikesys.db')
c = conn.cursor()
print("数据库打开成功")

cursor = c.execute("SELECT id, salary  from BIKE_INCOME")
for row in cursor:
    print("ID = ", row[0])
    print("SALARY = ", row[1], "\n")

print("数据操作成功")
conn.close()
